{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Switchgrass L Input-L Yield","Switchgrass L Input-H Yield","Switchgrass L Input-1 cut","Switchgrass L Input-2 cut","Tall Fescue L Input-1 cut","Tall Fescue L Input-2 cut","Switchgrass H Input-1 cut","Switchgrass H Input-2 cut","Switchgrass H Input-3 cut","Tall Fescue H Input-1 cut","Tall Fescue H Input-2 cut","Tall Fescue H Input-3 cut","Introduced Mix L Input-1 cut","Introduced Mix L Input-2 cut","Introduced Mix H Input-1 cut","Intoduced Mix H Input-2 cut","Intoduced Mix H Input-3 cut","Native Mix L Input-1 cut","Native Mix H Input-1 cut","Native Mix H Input-2 cut","Native Mix H Input-3 cut","Native Mix L Input-2 cut","Source List","BUDGET CALCULATOR","Instructions"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":23,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Switchgrass L Input-L Yield","index":0,"n_rows":91,"n_cols":11,"rows_kept":91,"cut":false,"hidden":true,"merged":[]}
["Switchgrass","Low Input Low Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!#REF!","v":{"$error":"#REF!"}}]
[]
["Establishment"]
[]
["Efficient Producer",null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J9*1.2","v":0.1656}]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,{"$f":"J11*1.2","v":0.1668}]
[null,null,null,null,"6 pounds seed (3 Blackwell, 3 Dacotah)",2.39,{"$f":"F12*6","v":14.34}]
[]
["Reeseding"]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J15*1.2","v":0.1656}]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F16*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,{"$f":"J17*1.2","v":0.1668}]
[null,null,null,null,"6 pounds seed (3 Blackwell, 3 Dacotah)",2.39,{"$f":"F18*6","v":14.34}]
[]
["Inefficient Producer",null,"Disking","15 foot tandem disk",null,null,null,{"$f":"2.48/2.52","v":0.98412698412698407},1.03,0.154,{"$f":"J20*1.2","v":0.18479999999999999}]
[null,null,"Raking","30 foot Hay Rake",null,null,null,{"$f":"1.7/2.52","v":0.67460317460317454},0.45,0.10100000000000001,{"$f":"J21*1.2","v":0.1212}]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,{"$f":"J23*1.2","v":0.18239999999999998}]
[]
["Yearly"]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J26*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F27*60","v":16.080000000000002}]
[null,null,null,null,"1 Qt 2,4-D Herbacide","13/gal",3.25]
[]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J30*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,{"$f":"J31*1.2","v":0.25439999999999996}]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J32*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F33*$C$2","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals Efficient Producer",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":84.64},{"$f":"SUM(H7:H11)+H23","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I23","v":8.5},{"$f":"SUM(J7:J11)+J23","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K23","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K46*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H46*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G46+'BUDGET CALCULATOR'!C8","v":84.64}]
[]
["Total Establishment Cost (Efficient Producer)",null,{"$f":"G49+H48+I46+K47","v":93.14}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C51*('BUDGET CALCULATOR'!#REF!)))/((1-(1+('BUDGET CALCULATOR'!#REF!))^-10))","v":{"$error":"#REF!"}}]
[]
["TOTAL EFFICIENT PRODUCER ESTABLISHMENT COST:",null,{"$f":"SUM(C51:C53)","v":{"$error":"#REF!"}}]
[]
["Establishment Totals Inefficient Producer",null,null,null,null,null,{"$f":"G46","v":84.64},{"$f":"SUM((H7:H11,H20:H23))","v":7.0796825396825396},{"$f":"SUM((I7:I11,I20:I23))","v":9.98},{"$f":"SUM((J7:J11,J20:J23))","v":1.0428081534772182},{"$f":"SUM((K7:K11,K20:K23))","v":1.2513697841726619}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K57*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H57*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G57+'BUDGET CALCULATOR'!C8","v":84.64}]
[]
["Total Establishment Cost (Inefficient Producer)",null,{"$f":"G60+H59+I57+K58","v":94.62}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C62*('BUDGET CALCULATOR'!#REF!)))/((1-(1+('BUDGET CALCULATOR'!#REF!))^-10))","v":{"$error":"#REF!"}}]
[]
["TOTAL INEFFICIENT PRODUCER ESTABLISHMENT COST:",null,{"$f":"SUM(C62:C64)","v":{"$error":"#REF!"}}]
[]
["Reeseding Costs",null,null,null,null,null,{"$f":"SUM(G16:G18)","v":84.64},{"$f":"SUM(H15:H17)","v":1.8492063492063493},{"$f":"SUM(I15:I17)","v":2.9},0.27700000000000002,0.33240000000000003]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K68*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H68*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G68+'BUDGET CALCULATOR'!$C$8","v":84.64}]
[]
["Total Reeseding Costs",{"$f":"G71+H70+I68+K69","v":87.54}]
[]
["TOTAL EXPECTED REESEDING COSTS (Reeseding once every four years)",{"$f":"0.25*B73","v":21.885000000000002}]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G26:G37)","v":{"$error":"#REF!"}},{"$f":"SUM(H26:H38)","v":4.2944444444444443},9.66,0.66992899408284023,0.80391479289940826]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K77*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H77*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G77+'BUDGET CALCULATOR'!C8","v":{"$error":"#REF!"}}]
[]
["Total Annual Cost ",null,{"$f":"G80+H79+I77+K78","v":{"$error":"#REF!"}}]
["Total Annual Cost with ammortized reesding costs",null,{"$f":"C82+B75","v":{"$error":"#REF!"}}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C83*('BUDGET CALCULATOR'!#REF!/12)))/((1-((1+('BUDGET CALCULATOR'!#REF!/12))^-6)))*0.5","v":{"$error":"#REF!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C83:C85)","v":{"$error":"#REF!"}}]
[]
["TOTAL PER ACRE COST (Efficient Producer)",null,{"$f":"C87+C53","v":{"$error":"#REF!"}}]
[]
["TOTAL PER ACRE COST (Inefficient Producer)",null,{"$f":"C87+C64","v":{"$error":"#REF!"}}]

{"sheet":"Switchgrass L Input-H Yield","index":1,"n_rows":91,"n_cols":11,"rows_kept":91,"cut":false,"hidden":true,"merged":[]}
["Switchgrass","High Input Low Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!#REF!","v":{"$error":"#REF!"}}]
[]
["Establishment"]
[]
["Efficient Producer",null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J9*1.2","v":0.1656}]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,{"$f":"J11*1.2","v":0.1668}]
[null,null,null,null,"6 pounds seed (3 Blackwell, 3 Dacotah)",2.39,{"$f":"F12*6","v":14.34}]
[]
["Reeseding"]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J15*1.2","v":0.1656}]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F16*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,{"$f":"J17*1.2","v":0.1668}]
[null,null,null,null,"6 pounds seed (3 Blackwell, 3 Dacotah)",2.39,{"$f":"F18*6","v":14.34}]
[]
["Inefficient Producer",null,"Disking","15 foot tandem disk",null,null,null,{"$f":"2.48/2.52","v":0.98412698412698407},1.03,0.154,{"$f":"J20*1.2","v":0.18479999999999999}]
[null,null,"Raking","30 foot Hay Rake",null,null,null,{"$f":"1.7/2.52","v":0.67460317460317454},0.45,0.10100000000000001,{"$f":"J21*1.2","v":0.1212}]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,{"$f":"J23*1.2","v":0.18239999999999998}]
[]
["Yearly"]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J26*1.2","v":0.1656}]
[null,null,null,null,"30 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F27*30","v":8.0400000000000009}]
[null,null,null,null,"1 Qt 2,4-D Herbacide","13/gal",3.25]
[]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J30*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,{"$f":"J31*1.2","v":0.25439999999999996}]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J32*1.2","v":0.17751479289940827}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J33*1.2","v":0.1656}]
[null,null,null,null,"30 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F34*30","v":8.0400000000000009}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J35*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,{"$f":"J36*1.2","v":0.25439999999999996}]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J37*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F38*$C$2","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals Efficient Producer",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":84.64},{"$f":"SUM(H7:H11)+H23","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I23","v":8.5},{"$f":"SUM(J7:J11)+J23","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K23","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K46*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H46*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G46+'BUDGET CALCULATOR'!C8","v":84.64}]
[]
["Total Establishment Cost (Efficient Producer)",null,{"$f":"G49+H48+I46+K47","v":93.14}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C51*('BUDGET CALCULATOR'!#REF!)))/((1-(1+('BUDGET CALCULATOR'!#REF!))^-10))","v":{"$error":"#REF!"}}]
[]
["TOTAL EFFICIENT PRODUCER ESTABLISHMENT COST:",null,{"$f":"SUM(C51:C53)","v":{"$error":"#REF!"}}]
[]
["Establishment Totals Inefficient Producer",null,null,null,null,null,{"$f":"G46","v":84.64},{"$f":"SUM((H7:H11,H20:H23))","v":7.0796825396825396},{"$f":"SUM((I7:I11,I20:I23))","v":9.98},{"$f":"SUM((J7:J11,J20:J23))","v":1.0428081534772182},{"$f":"SUM((K7:K11,K20:K23))","v":1.2513697841726619}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K57*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H57*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G57+'BUDGET CALCULATOR'!C8","v":84.64}]
[]
["Total Establishment Cost (Inefficient Producer)",null,{"$f":"G60+H59+I57+K58","v":94.62}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C62*('BUDGET CALCULATOR'!#REF!)))/((1-(1+('BUDGET CALCULATOR'!#REF!))^-10))","v":{"$error":"#REF!"}}]
[]
["TOTAL INEFFICIENT PRODUCER ESTABLISHMENT COST:",null,{"$f":"SUM(C62:C64)","v":{"$error":"#REF!"}}]
[]
["Reeseding Costs",null,null,null,null,null,{"$f":"SUM(G16:G18)","v":84.64},{"$f":"SUM(H15:H17)","v":1.8492063492063493},{"$f":"SUM(I15:I17)","v":2.9},0.27700000000000002,0.33240000000000003]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K68*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H68*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G68+'BUDGET CALCULATOR'!$C$8","v":84.64}]
[]
["Total Reeseding Costs",{"$f":"G71+H70+I68+K69","v":87.54}]
[]
["TOTAL EXPECTED REESEDING COSTS (Reeseding once every four years)",{"$f":"0.25*B73","v":21.885000000000002}]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G26:G38)","v":{"$error":"#REF!"}},{"$f":"SUM(H26:H38)","v":8.5888888888888868},19.32,1.3398579881656805,1.6078295857988165]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K77*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H77*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G77+'BUDGET CALCULATOR'!C8","v":{"$error":"#REF!"}}]
[]
["Total Annual Cost ",null,{"$f":"G80+H79+I77+K78","v":{"$error":"#REF!"}}]
["Total Annual Cost with ammortized reesding costs",null,{"$f":"C82+B75","v":{"$error":"#REF!"}}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C83*('BUDGET CALCULATOR'!#REF!/12)))/((1-((1+('BUDGET CALCULATOR'!#REF!/12))^-6)))*0.5","v":{"$error":"#REF!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C83:C85)","v":{"$error":"#REF!"}}]
[]
["TOTAL PER ACRE COST (Efficient Producer)",null,{"$f":"C87+C53","v":{"$error":"#REF!"}}]
[]
["TOTAL PER ACRE COST (Inefficient Producer)",null,{"$f":"C87+C64","v":{"$error":"#REF!"}}]

{"sheet":"Switchgrass L Input-1 cut","index":2,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Tall Fescue","Low Input Low Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!I17","v":0}]
[null,"N Per Cutting",60]
["Establishment"]
[]
[" Producer",null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"10 pounds seed (10  Fawn or Alta)",0.65,{"$f":"F12*10","v":6.5}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[null,null,"Operation","Equipment","Material Needed","Amount (Unit)/Price","Total Price"]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!I20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,{"$f":"J24*1.2","v":0.25439999999999996}]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F26*$C$2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals ",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":76.8},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":76.8}]
[]
["Total Establishment Cost ",null,{"$f":"G51+H50+I48+K49","v":85.3}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G30)","v":0},{"$f":"SUM(H15:H30)","v":5.7785714285714285},{"$f":"SUM(I15:I30)","v":10.95},{"$f":"SUM(J15:J30)","v":0.82192899408284026},{"$f":"SUM(K15:K30)","v":0.98631479289940827}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K60*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H60*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G60+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G63+H62+I60+K61","v":10.95}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C65*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C65:C67)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST (Efficient Producer)",null,{"$f":"C69+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Switchgrass L Input-2 cut","index":3,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Tall Fescue","Low Input High Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!I17","v":0}]
[null,"N Per Cutting",30]
["Establishment"]
[]
[" Producer",null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"10 pounds seed (10  Fawn or Alta)",0.65,{"$f":"F12*10","v":6.5}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[null,null,"Operation","Equipment","Material Needed","Amount (Unit)/Price","Total Price"]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"30 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!I20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"30 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F27*'BUDGET CALCULATOR'!I20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,0.20639999999999997]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J30*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F31*$C$2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals Efficient Producer",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":76.8},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":76.8}]
[]
["Total Establishment Cost ",null,{"$f":"G51+H50+I48+K49","v":85.3}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G30)","v":0},{"$f":"SUM(H15:H30)","v":10.073015873015871},{"$f":"SUM(I15:I30)","v":20.61},{"$f":"SUM(J15:J30)","v":1.4918579881656806},{"$f":"SUM(K15:K30)","v":1.7902295857988164}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K60*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H60*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G60+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G63+H62+I60+K61","v":20.61}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C65*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C65:C67)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST",null,{"$f":"C69+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Tall Fescue L Input-1 cut","index":4,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Tall Fescue","Low Input Low Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!I17","v":0}]
[null,"N Per Cutting",60]
["Establishment"]
[]
[" Producer",null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"10 pounds seed (10  Fawn or Alta)",0.65,{"$f":"F12*10","v":6.5}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[null,null,"Operation","Equipment","Material Needed","Amount (Unit)/Price","Total Price"]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!I20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,{"$f":"J24*1.2","v":0.25439999999999996}]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F26*$C$2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals ",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":76.8},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":76.8}]
[]
["Total Establishment Cost ",null,{"$f":"G51+H50+I48+K49","v":85.3}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G30)","v":0},{"$f":"SUM(H15:H30)","v":5.7785714285714285},{"$f":"SUM(I15:I30)","v":10.95},{"$f":"SUM(J15:J30)","v":0.82192899408284026},{"$f":"SUM(K15:K30)","v":0.98631479289940827}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K60*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H60*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G60+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G63+H62+I60+K61","v":10.95}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C65*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C65:C67)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST (Efficient Producer)",null,{"$f":"C69+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Tall Fescue L Input-2 cut","index":5,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Tall Fescue","Low Input High Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!I17","v":0}]
[null,"N Per Cutting",30]
["Establishment"]
[]
[" Producer",null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"10 pounds seed (10  Fawn or Alta)",0.65,{"$f":"F12*10","v":6.5}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[null,null,"Operation","Equipment","Material Needed","Amount (Unit)/Price","Total Price"]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"30 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!I20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"30 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F27*'BUDGET CALCULATOR'!I20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,0.20639999999999997]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J30*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F31*$C$2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals Efficient Producer",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":76.8},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":76.8}]
[]
["Total Establishment Cost ",null,{"$f":"G51+H50+I48+K49","v":85.3}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G30)","v":0},{"$f":"SUM(H15:H30)","v":10.073015873015871},{"$f":"SUM(I15:I30)","v":20.61},{"$f":"SUM(J15:J30)","v":1.4918579881656806},{"$f":"SUM(K15:K30)","v":1.7902295857988164}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K60*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H60*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G60+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G63+H62+I60+K61","v":20.61}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C65*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C65:C67)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST",null,{"$f":"C69+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Switchgrass H Input-1 cut","index":6,"n_rows":77,"n_cols":11,"rows_kept":77,"cut":false,"hidden":true,"merged":[]}
["Switchgrass","HIgh Input Low Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!L17","v":0}]
[null,"N per cutting",120]
["Establishment"]
[]
[" Producer",null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J9*1.2","v":0.1656}]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,{"$f":"J11*1.2","v":0.1668}]
[null,null,null,null,"6 pounds seed (3 Blackwell, 3 Dacotah)",2.39,{"$f":"F12*6","v":14.34}]
[]
["Reeseding"]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J15*1.2","v":0.1656}]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F16*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,{"$f":"J17*1.2","v":0.1668}]
[null,null,null,null,"6 pounds seed (3 Blackwell, 3 Dacotah)",2.39,{"$f":"F18*6","v":14.34}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,{"$f":"J21*1.2","v":0.18239999999999998}]
[]
["Yearly"]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J24*1.2","v":0.1656}]
[null,null,null,null,"120 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F25*'BUDGET CALCULATOR'!L20","v":0}]
[null,null,null,null,"1 Qt 2,4-D Herbacide","13/gal",3.25]
[]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J28*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,{"$f":"J29*1.2","v":0.25439999999999996}]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J30*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F31*$C$2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":84.64},{"$f":"SUM(H7:H11)+H21","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I21","v":8.5},{"$f":"SUM(J7:J11)+J21","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K21","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K44*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H44*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G44+'BUDGET CALCULATOR'!C8","v":84.64}]
[]
["Total Establishment Cost ",null,{"$f":"G47+H46+I44+K45","v":93.14}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C49*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL  ESTABLISHMENT COST:",null,{"$f":"SUM(C49:C51)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Reeseding Costs",null,null,null,null,null,{"$f":"SUM(G16:G18)","v":84.64},{"$f":"SUM(H15:H17)","v":1.8492063492063493},{"$f":"SUM(I15:I17)","v":2.9},{"$f":"SUM(J15:J17)","v":0.27700000000000002},{"$f":"SUM(K15:K17)","v":0.33240000000000003}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K56*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H56*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G56+'BUDGET CALCULATOR'!$C$8","v":84.64}]
[]
["Total Reeseding Costs",{"$f":"G59+H58+I56+K57","v":87.54}]
[]
["TOTAL EXPECTED REESEDING COSTS (Reeseding once every four years)",{"$f":"0.25*B61","v":21.885000000000002}]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G24:G36)","v":3.25},{"$f":"SUM(H24:H36)","v":4.2944444444444443},9.66,0.66992899408284023,0.80391479289940826]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K65*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H65*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G65+'BUDGET CALCULATOR'!C8","v":3.25}]
[]
["Total Annual Cost ",null,{"$f":"G68+H67+I65+K66","v":12.91}]
["Total Annual Cost with ammortized reesding costs",null,{"$f":"C70+B63","v":34.795000000000002}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C71*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C71:C73)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST ",null,{"$f":"C75+C51","v":{"$error":"#DIV/0!"}}]

{"sheet":"Switchgrass H Input-2 cut","index":7,"n_rows":78,"n_cols":11,"rows_kept":78,"cut":false,"hidden":true,"merged":[]}
["Switchgrass","HIgh Input HIgh Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!L17","v":0}]
[null,"N per cutting",60]
["Establishment"]
[]
[" Producer",null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J9*1.2","v":0.1656}]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,{"$f":"J11*1.2","v":0.1668}]
[null,null,null,null,"6 pounds seed (3 Blackwell, 3 Dacotah)",2.39,{"$f":"F12*6","v":14.34}]
[]
["Reeseding"]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J15*1.2","v":0.1656}]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F16*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,{"$f":"J17*1.2","v":0.1668}]
[null,null,null,null,"6 pounds seed (3 Blackwell, 3 Dacotah)",2.39,{"$f":"F18*6","v":14.34}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,{"$f":"J21*1.2","v":0.18239999999999998}]
[]
["Yearly"]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J24*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F25*'BUDGET CALCULATOR'!L20","v":0}]
[null,null,null,null,"1 Qt 2,4-D Herbacide","13/gal",3.25]
[]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J28*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,{"$f":"J29*1.2","v":0.25439999999999996}]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J30*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F31*$C$2","v":0}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J32*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F33*60","v":16.080000000000002}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J34*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,{"$f":"J35*1.2","v":0.25439999999999996}]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J36*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F37*$C$2","v":0}]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals ",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":84.64},{"$f":"SUM(H7:H11)+H21","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I21","v":8.5},{"$f":"SUM(J7:J11)+J21","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K21","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K45*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H45*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G45+'BUDGET CALCULATOR'!C8","v":84.64}]
[]
["Total Establishment Cost",null,{"$f":"G48+H47+I45+K46","v":93.14}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C50*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ESTABLISHMENT COST:",null,{"$f":"SUM(C50:C52)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Reeseding Costs",null,null,null,null,null,{"$f":"SUM(G16:G18)","v":84.64},{"$f":"SUM(H15:H17)","v":1.8492063492063493},{"$f":"SUM(I15:I17)","v":2.9},{"$f":"SUM(J15:J17)","v":0.27700000000000002},{"$f":"SUM(K15:K17)","v":0.33240000000000003}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K57*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H57*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G57+'BUDGET CALCULATOR'!$C$8","v":84.64}]
[]
["Total Reeseding Costs",{"$f":"G60+H59+I57+K58","v":87.54}]
[]
["TOTAL EXPECTED REESEDING COSTS (Reeseding once every four years)",{"$f":"0.25*B62","v":21.885000000000002}]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G24:G37)","v":19.330000000000002},{"$f":"SUM(H24:H37)","v":8.5888888888888868},19.32,1.3398579881656805,1.6078295857988165]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K66*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H66*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G66+'BUDGET CALCULATOR'!C8","v":19.330000000000002}]
[]
["Total Annual Cost ",null,{"$f":"G69+H68+I66+K67","v":38.650000000000006}]
["Total Annual Cost with ammortized reesding costs",null,{"$f":"C71+B64","v":60.535000000000011}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C72*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C72:C74)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST ",null,{"$f":"C76+C52","v":{"$error":"#DIV/0!"}}]

{"sheet":"Switchgrass H Input-3 cut","index":8,"n_rows":84,"n_cols":11,"rows_kept":84,"cut":false,"hidden":true,"merged":[]}
["Switchgrass","HIgh Input HIgh Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!L17","v":0}]
[null,"N per Cutting",60]
["Establishment"]
[]
[" Producer",null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J9*1.2","v":0.1656}]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,{"$f":"J11*1.2","v":0.1668}]
[null,null,null,null,"6 pounds seed (3 Blackwell, 3 Dacotah)",2.39,{"$f":"F12*6","v":14.34}]
[]
["Reeseding"]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J15*1.2","v":0.1656}]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F16*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,{"$f":"J17*1.2","v":0.1668}]
[null,null,null,null,"6 pounds seed (3 Blackwell, 3 Dacotah)",2.39,{"$f":"F18*6","v":14.34}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,{"$f":"J21*1.2","v":0.18239999999999998}]
[]
["Yearly"]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J24*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F25*'BUDGET CALCULATOR'!L20","v":0}]
[null,null,null,null,"1 Qt 2,4-D Herbacide","13/gal",3.25]
[]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J28*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,{"$f":"J29*1.2","v":0.25439999999999996}]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J30*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F31*$C$2","v":0}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J32*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F33*60","v":16.080000000000002}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J34*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,{"$f":"J35*1.2","v":0.25439999999999996}]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J36*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F37*$C$2","v":0}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J38*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F39*60","v":16.080000000000002}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J40*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,{"$f":"J41*1.2","v":0.25439999999999996}]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J42*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F43*$C$2","v":0}]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals ",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":84.64},{"$f":"SUM(H7:H11)+H21","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I21","v":8.5},{"$f":"SUM(J7:J11)+J21","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K21","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K51*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H51*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G51+'BUDGET CALCULATOR'!C8","v":84.64}]
[]
["Total Establishment Cost",null,{"$f":"G54+H53+I51+K52","v":93.14}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C56*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ESTABLISHMENT COST:",null,{"$f":"SUM(C56:C58)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Reeseding Costs",null,null,null,null,null,{"$f":"SUM(G16:G18)","v":84.64},{"$f":"SUM(H15:H17)","v":1.8492063492063493},{"$f":"SUM(I15:I17)","v":2.9},{"$f":"SUM(J15:J17)","v":0.27700000000000002},{"$f":"SUM(K15:K17)","v":0.33240000000000003}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K63*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H63*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G63+'BUDGET CALCULATOR'!$C$8","v":84.64}]
[]
["Total Reeseding Costs",{"$f":"G66+H65+I63+K64","v":87.54}]
[]
["TOTAL EXPECTED REESEDING COSTS (Reeseding once every four years)",{"$f":"0.25*B68","v":21.885000000000002}]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G24:G43)","v":35.410000000000004},{"$f":"SUM(H24:H43)","v":12.883333333333329},{"$f":"SUM(I24:I43)","v":28.98},{"$f":"SUM(J24:J43)","v":2.0097869822485208},{"$f":"SUM(K24:K43)","v":2.4117443786982249}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K72*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H72*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G72+'BUDGET CALCULATOR'!C8","v":35.410000000000004}]
[]
["Total Annual Cost ",null,{"$f":"G75+H74+I72+K73","v":64.39}]
["Total Annual Cost with ammortized reesding costs",null,{"$f":"C77+B70","v":86.275000000000006}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C78*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C78:C80)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST ",null,{"$f":"C82+C58","v":{"$error":"#DIV/0!"}}]

{"sheet":"Tall Fescue H Input-1 cut","index":9,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Tall Fescue","High Input Low Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!I17","v":0}]
[null,"N Per Cutting ",120]
["Establishment"]
[]
[" Producer",null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"10 pounds seed (10  Fawn or Alta)",0.65,{"$f":"F12*10","v":6.5}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[null,null,"Operation","Equipment","Material Needed","Amount (Unit)/Price","Total Price"]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"120 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!I20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,{"$f":"J24*1.2","v":0.25439999999999996}]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F26*$C$2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals ",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":76.8},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":76.8}]
[]
["Total Establishment Cost ",null,{"$f":"G51+H50+I48+K49","v":85.3}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL  ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G30)","v":0},{"$f":"SUM(H15:H30)","v":5.7785714285714285},{"$f":"SUM(I15:I30)","v":10.95},{"$f":"SUM(J15:J30)","v":0.82192899408284026},{"$f":"SUM(K15:K30)","v":0.98631479289940827}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K60*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H60*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G60+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G63+H62+I60+K61","v":10.95}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C65*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C65:C67)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST (Efficient Producer)",null,{"$f":"C69+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Tall Fescue H Input-2 cut","index":10,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Tall Fescue","High Input High Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!I17","v":0}]
[null,"N Per Cutting ",60]
["Establishment"]
[]
[" Producer",null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"10 pounds seed (10  Fawn or Alta)",0.65,{"$f":"F12*10","v":6.5}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[null,null,"Operation","Equipment","Material Needed","Amount (Unit)/Price","Total Price"]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!I20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F27*'BUDGET CALCULATOR'!I20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,0.20639999999999997]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J30*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F31*$C$2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals ",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":76.8},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":76.8}]
[]
["Total Establishment Cost",null,{"$f":"G51+H50+I48+K49","v":85.3}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL  ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G30)","v":0},{"$f":"SUM(H15:H30)","v":10.073015873015871},{"$f":"SUM(I15:I30)","v":20.61},{"$f":"SUM(J15:J30)","v":1.4918579881656806},{"$f":"SUM(K15:K30)","v":1.7902295857988164}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K60*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H60*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G60+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G63+H62+I60+K61","v":20.61}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C65*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C65:C67)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST (Efficient Producer)",null,{"$f":"C69+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Tall Fescue H Input-3 cut","index":11,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Tall Fescue","High Input High Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!I17","v":0}]
[null,"N Per Cutting",60]
["Establishment"]
[]
[" Producer",null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"10 pounds seed (10  Fawn or Alta)",0.65,{"$f":"F12*10","v":6.5}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[null,null,"Operation","Equipment","Material Needed","Amount (Unit)/Price","Total Price"]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!I20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F27*'BUDGET CALCULATOR'!I20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,0.20639999999999997]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J30*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F31*$C$2","v":0}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J32*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F33*'BUDGET CALCULATOR'!I20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J34*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J36*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F37*$C$2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals ",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":76.8},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":76.8}]
[]
["Total Establishment Cost",null,{"$f":"G51+H50+I48+K49","v":85.3}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL  ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G37)","v":0},{"$f":"SUM(H15:H37)","v":14.367460317460313},{"$f":"SUM(I15:I37)","v":30.27},{"$f":"SUM(J15:J37)","v":2.1617869822485209},{"$f":"SUM(K15:K37)","v":2.5941443786982248}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K60*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H60*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G60+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G63+H62+I60+K61","v":30.27}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C65*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C65:C67)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST (Efficient Producer)",null,{"$f":"C69+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Introduced Mix L Input-1 cut","index":12,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Introduced Mix","Low Input Low Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!F17","v":0}]
[null,"N Per Cutting",60]
["Establishment"]
[]
[" Producer",null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"20 pounds seed (7 Meadow Brome-Cache, 4 Tall Fescue-Fawn, 4 Orchardgrass, 4 Alfala)",1.5,{"$f":"F12*20","v":30}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[null,null,"Operation","Equipment","Material Needed","Amount (Unit)/Price","Total Price"]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!F20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,{"$f":"J24*1.2","v":0.25439999999999996}]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F26*$C$2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":100.3},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":100.3}]
[]
["Total Establishment Cost ",null,{"$f":"G51+H50+I48+K49","v":108.8}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL  ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G30)","v":0},{"$f":"SUM(H15:H30)","v":5.7785714285714285},{"$f":"SUM(I15:I30)","v":10.95},{"$f":"SUM(J15:J30)","v":0.82192899408284026},{"$f":"SUM(K15:K30)","v":0.98631479289940827}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K60*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H60*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G60+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G63+H62+I60+K61","v":10.95}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C65*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C65:C67)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST (Efficient Producer)",null,{"$f":"C69+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Introduced Mix L Input-2 cut","index":13,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Introduced Mix","Low Input High Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!F17","v":0}]
[null,"N Per Cutting",30]
["Establishment"]
[null,null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[" Producer"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"20 pounds seed (7 Meadow Brome-Cache, 4 Tall Fescue-Fawn, 4 Orchardgrass, 4 Alfala)",1.5,{"$f":"F12*20","v":30}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[null,null,"Operation","Equipment","Material Needed","Amount (Unit)/Price","Total Price"]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"30 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!F20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"30 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F27*'BUDGET CALCULATOR'!F20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,0.20639999999999997]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J30*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F31*$C$2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":100.3},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":100.3}]
[]
["Total Establishment Cost ",null,{"$f":"G51+H50+I48+K49","v":108.8}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G30)","v":0},{"$f":"SUM(H15:H30)","v":10.073015873015871},{"$f":"SUM(I15:I30)","v":20.61},{"$f":"SUM(J15:J30)","v":1.4918579881656806},{"$f":"SUM(K15:K30)","v":1.7902295857988164}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K60*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H60*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G60+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G63+H62+I60+K61","v":20.61}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C65*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C65:C67)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST (Efficient Producer)",null,{"$f":"C69+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Introduced Mix H Input-1 cut","index":14,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Introduced Mix","High Input Low Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!F17","v":0}]
[null,"N Per Cutting",120]
["Establishment"]
[null,null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[" Producer"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"20 pounds seed (7 Meadow Brome-Cache, 4 Tall Fescue-Fawn, 4 Orchardgrass, 4 Alfala)",1.5,{"$f":"F12*20","v":30}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[null,null,"Operation","Equipment","Material Needed","Amount (Unit)/Price","Total Price"]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"120 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!F20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,{"$f":"J24*1.2","v":0.25439999999999996}]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F26*$C$2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals ",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":100.3},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":100.3}]
[]
["Total Establishment Cost ",null,{"$f":"G51+H50+I48+K49","v":108.8}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G30)","v":0},{"$f":"SUM(H15:H30)","v":5.7785714285714285},{"$f":"SUM(I15:I30)","v":10.95},{"$f":"SUM(J15:J30)","v":0.82192899408284026},{"$f":"SUM(K15:K30)","v":0.98631479289940827}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K60*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H60*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G60+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G63+H62+I60+K61","v":10.95}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C65*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C65:C67)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST (Efficient Producer)",null,{"$f":"C69+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Intoduced Mix H Input-2 cut","index":15,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Introduced Mix","High Input High Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!F17","v":0}]
[null,"N Per Cutting",60]
["Establishment"]
[null,null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[" Producer"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"20 pounds seed (7 Meadow Brome-Cache, 4 Tall Fescue-Fawn, 4 Orchardgrass, 4 Alfala)",1.5,{"$f":"F12*20","v":30}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[null,null,"Operation","Equipment","Material Needed","Amount (Unit)/Price","Total Price"]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!F20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F27*'BUDGET CALCULATOR'!F20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,0.20639999999999997]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J30*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F31*C2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals ",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":100.3},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":100.3}]
[]
["Total Establishment Cost ",null,{"$f":"G51+H50+I48+K49","v":108.8}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL  ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G30)","v":0},{"$f":"SUM(H15:H30)","v":10.073015873015871},{"$f":"SUM(I15:I30)","v":20.61},{"$f":"SUM(J15:J30)","v":1.4918579881656806},{"$f":"SUM(K15:K30)","v":1.7902295857988164}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K60*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H60*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G60+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G63+H62+I60+K61","v":20.61}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C65*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C65:C67)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST (Efficient Producer)",null,{"$f":"C69+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Intoduced Mix H Input-3 cut","index":16,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Introduced Mix","High Input High Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!F17","v":0}]
[null,"N Per Cutting",60]
["Establishment"]
[null,null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[" Producer"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"20 pounds seed (7 Meadow Brome-Cache, 4 Tall Fescue-Fawn, 4 Orchardgrass, 4 Alfala)",1.5,{"$f":"F12*20","v":30}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[null,null,"Operation","Equipment","Material Needed","Amount (Unit)/Price","Total Price"]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!F20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F27*'BUDGET CALCULATOR'!F20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,0.20639999999999997]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J30*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F31*C2","v":0}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J32*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F33*'BUDGET CALCULATOR'!F20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J34*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J36*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F37*C2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals ",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":100.3},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":100.3}]
[]
["Total Establishment Cost ",null,{"$f":"G51+H50+I48+K49","v":108.8}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL  ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G37)","v":0},{"$f":"SUM(H15:H37)","v":14.367460317460313},{"$f":"SUM(I15:I37)","v":30.27},{"$f":"SUM(J15:J37)","v":2.1617869822485209},{"$f":"SUM(K15:K37)","v":2.5941443786982248}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K60*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H60*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G60+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G63+H62+I60+K61","v":30.27}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C65*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C65:C67)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST (Efficient Producer)",null,{"$f":"C69+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Native Mix L Input-1 cut","index":17,"n_rows":70,"n_cols":11,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
["Native Mix","Low Input Low Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!C17","v":0}]
[null,"N Per Cutting",60]
["Establishment"]
[null,null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"16 pounds seed (7 Great Basin Wildrye, 3 Slender Wheatgrass, 3 Bluebunch Wheatgrass, 3 Western Wheatgrass)",3.23,{"$f":"F12*16","v":51.68}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[null,null,"Operation","Equipment","Material Needed","Amount (Unit)/Price","Total Price"]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!C20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"C2*F26","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals ",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":121.97999999999999},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":121.97999999999999}]
[]
["Total Establishment Cost ",null,{"$f":"G51+H50+I48+K49","v":130.47999999999999}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G30)","v":0},{"$f":"SUM(H15:H30)","v":5.7785714285714285},{"$f":"SUM(I15:I30)","v":10.95},{"$f":"SUM(J15:J30)","v":0.82192899408284026},{"$f":"SUM(K15:K30)","v":0.98631479289940827}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K59*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H59*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G59+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G62+H61+I59+K60","v":10.95}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C64*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C64:C66)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST (Efficient Producer)",null,{"$f":"C68+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Native Mix H Input-1 cut","index":18,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Native Mix","High Input Low Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!C17","v":0}]
[null,"N Per Cutting",120]
["Establishment"]
[null,null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[" Producer"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"16 pounds seed (7 Great Basin Wildrye, 3 Slender Wheatgrass, 3 Bluebunch Wheatgrass, 3 Western Wheatgrass)",3.23,{"$f":"F12*16","v":51.68}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"120 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!C20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F26*C2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals ",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":121.97999999999999},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":121.97999999999999}]
[]
["Total Establishment Cost ",null,{"$f":"G51+H50+I48+K49","v":130.47999999999999}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G30)","v":0},{"$f":"SUM(H15:H30)","v":5.7785714285714285},{"$f":"SUM(I15:I30)","v":10.95},{"$f":"SUM(J15:J30)","v":0.82192899408284026},{"$f":"SUM(K15:K30)","v":0.98631479289940827}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K60*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H60*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G60+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G63+H62+I60+K61","v":10.95}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C65*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C65:C67)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST (Efficient Producer)",null,{"$f":"C69+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Native Mix H Input-2 cut","index":19,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Native Mix","High Input High Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!C17","v":0}]
[null,"N Per Cutting",60]
["Establishment"]
[null,null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[" Producer"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"16 pounds seed (7 Great Basin Wildrye, 3 Slender Wheatgrass, 3 Bluebunch Wheatgrass, 3 Western Wheatgrass)",3.23,{"$f":"F12*16","v":51.68}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!C20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F27*'BUDGET CALCULATOR'!C20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,0.20639999999999997]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J30*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F31*C2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals ",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":121.97999999999999},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":121.97999999999999}]
[]
["Total Establishment Cost ",null,{"$f":"G51+H50+I48+K49","v":130.47999999999999}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL  ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G31)","v":0},{"$f":"SUM(H15:H30)","v":10.073015873015871},{"$f":"SUM(I15:I30)","v":20.61},{"$f":"SUM(J15:J30)","v":1.4918579881656806},{"$f":"SUM(K15:K30)","v":1.7902295857988164}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K60*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H60*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G60+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G63+H62+I60+K61","v":20.61}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C65*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C65:C67)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST ",null,{"$f":"C69+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Native Mix H Input-3 cut","index":20,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Native Mix","High Input High Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!C17","v":0}]
[null,"N Per Cutting",60]
["Establishment"]
[null,null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[" Producer"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"16 pounds seed (7 Great Basin Wildrye, 3 Slender Wheatgrass, 3 Bluebunch Wheatgrass, 3 Western Wheatgrass)",3.23,{"$f":"F12*16","v":51.68}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!C20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F27*'BUDGET CALCULATOR'!C20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,0.20639999999999997]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J30*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F31*C2","v":0}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J32*1.2","v":0.1656}]
[null,null,null,null,"60 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F33*'BUDGET CALCULATOR'!C20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J34*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J36*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"F37*C2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals ",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":121.97999999999999},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":121.97999999999999}]
[]
["Total Establishment Cost ",null,{"$f":"G51+H50+I48+K49","v":130.47999999999999}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL  ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G37)","v":0},{"$f":"SUM(H15:H37)","v":14.367460317460313},{"$f":"SUM(I15:I37)","v":30.27},{"$f":"SUM(J15:J37)","v":2.1617869822485209},{"$f":"SUM(K15:K37)","v":2.5941443786982248}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K60*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H60*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G60+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G63+H62+I60+K61","v":30.27}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C65*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C65:C67)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST ",null,{"$f":"C69+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Native Mix L Input-2 cut","index":21,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Native Mix","Low Input High Yield"]
[null,"Total Yield (in tons)",{"$f":"'BUDGET CALCULATOR'!C17","v":0}]
[null,"N Per Cutting",30]
["Establishment"]
[null,null,"Operation","Equipment","Additional Material Needed","Amount (Unit)/Price","Total Price","MSBG Fuel (in gallons)","MSBG Maintenance Cost","MSBG Labor Hours","MSBG Labor with 1.2 multiplier"]
[" Producer"]
[null,null,"Plowing (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","4 bottom moldboard plow",null,null,null,1.29,{"$f":"1.86+2.04","v":3.9000000000000004},{"$f":"1/4.17","v":0.23980815347721823},{"$f":"J7*1.2","v":0.28776978417266186}]
[null,null,"Roller Harrow","15 foot cultipacker/rollerharrow",null,null,null,{"$f":"2.01/2.52","v":0.79761904761904756},0.41,0.11899999999999999,{"$f":"J8*1.2","v":0.14279999999999998}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"200 pounds 18-46-0 (DAP)",{"$f":"703/2000","v":0.35149999999999998},{"$f":"F10*200","v":70.3}]
[null,null,"Planting","12-15 foot drill",null,null,null,{"$f":"2.45/2.52","v":0.97222222222222232},1.68,0.13900000000000001,0.1668]
[null,null,null,null,"16 pounds seed (7 Great Basin Wildrye, 3 Slender Wheatgrass, 3 Bluebunch Wheatgrass, 3 Western Wheatgrass)",3.23,{"$f":"F12*16","v":51.68}]
[]
[]
["Irrigation",null,"Land Planing","12 foot land plane",null,null,null,{"$f":"3.74/2.52","v":1.4841269841269842},1.29,0.152,0.18239999999999998]
[]
[]
["Yearly"]
[]
[]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,{"$f":"J21*1.2","v":0.1656}]
[null,null,null,null,"30 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F22*'BUDGET CALCULATOR'!C20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,{"$f":"J23*1.2","v":0.20639999999999997}]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J25*1.2","v":0.17751479289940827}]
[null,null,"Fertilizer Application","Tractor pull cart with 40 foot swath",null,null,null,{"$f":"2.21/2.52","v":0.87698412698412698},1.22,0.13800000000000001,0.1656]
[null,null,null,null,"30 pounds Nitrogen Urea",{"$f":"536/2000","v":0.26800000000000002},{"$f":"F27*'BUDGET CALCULATOR'!C20","v":0}]
[null,null,"Swathing","14 foot swather",null,null,null,{"$f":"2.9/2.52","v":1.1507936507936507},2.67,0.17199999999999999,0.20639999999999997]
[null,null,"Baling ","Bailer",null,null,null,{"$f":"3.57/2.52","v":1.4166666666666665},3.36,0.21199999999999999,0.25439999999999996]
[null,null,"Hauling (FROM UNIVERSITY OF MINNESOTA EXTENSION, NOT MSGB, TWINE FROM UNIVERSITY OF NEBRASKA EXTENSION)","Baling Wagon",null,null,null,0.85,{"$f":"1.05+0.75+0.61","v":2.41},{"$f":"1/6.76","v":0.14792899408284024},{"$f":"J30*1.2","v":0.17751479289940827}]
[null,null,null,null,"Twine/ ton",0.76,{"$f":"C2*F31","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Establishment Totals ",null,null,null,null,null,{"$f":"SUM(G10:G12)","v":121.97999999999999},{"$f":"SUM(H7:H11)+H15","v":5.4209523809523805},{"$f":"SUM(I7:I11)+I15","v":8.5},{"$f":"SUM(J7:J11)+J15","v":0.78780815347721822},{"$f":"SUM(K7:K11)+K15","v":0.94536978417266193}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K48*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H48*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G48+'BUDGET CALCULATOR'!C8","v":121.97999999999999}]
[]
["Total Establishment Cost ",null,{"$f":"G51+H50+I48+K49","v":130.47999999999999}]
[]
["Annual Interest (Ammortized over 10 Years)",null,{"$f":"((C53*('BUDGET CALCULATOR'!C6)))/((1-(1+('BUDGET CALCULATOR'!C6))^-10))","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL  ESTABLISHMENT COST:",null,{"$f":"SUM(C53:C55)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Annual Totals",null,null,null,null,null,{"$f":"SUM(G21:G31)","v":0},{"$f":"SUM(H15:H30)","v":10.073015873015871},{"$f":"SUM(I15:I30)","v":20.61},{"$f":"SUM(J15:J30)","v":1.4918579881656806},{"$f":"SUM(K15:K30)","v":1.7902295857988164}]
[null,"Total With Labor",null,null,null,null,null,null,null,null,{"$f":"K60*'BUDGET CALCULATOR'!C5","v":0}]
[null,"Total with Fuel",null,null,null,null,null,{"$f":"H60*'BUDGET CALCULATOR'!C7","v":0}]
[null,"Total with Irrigation",null,null,null,null,{"$f":"G60+'BUDGET CALCULATOR'!C8","v":0}]
[]
["Total Annual Cost ",null,{"$f":"G63+H62+I60+K61","v":20.61}]
[]
["Total Interest (6 month loan)",null,{"$f":"((C65*('BUDGET CALCULATOR'!C6/12)))/((1-((1+('BUDGET CALCULATOR'!C6/12))^-6)))*0.5","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL ANNUAL COST",null,{"$f":"SUM(C65:C67)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL PER ACRE COST (Efficient Producer)",null,{"$f":"C69+C55","v":{"$error":"#DIV/0!"}}]

{"sheet":"Source List","index":22,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Source List"]
[]
["University of Minnesota Extension "]
["http://4h.umn.edu/distribution/businessmanagement/DF6696.pdf"]
[]
["Mississippi State Budget Generator Version 6"]
["CSU Created Mchinery Data Sets"]
[]
["Univeristy of Nebraska Extension"]
["http://johnson.unl.edu/c/document_library/get_file?uuid=62533adb-f389-4b02-ab84-f8a8b7916323&groupId=134973&.pdf"]

{"sheet":"BUDGET CALCULATOR","index":23,"n_rows":76,"n_cols":329,"rows_kept":76,"cut":false,"hidden":false,"merged":[[47,10,47,11],[0,0,1,4],[62,4,62,5],[62,7,62,8],[62,10,62,11],[32,1,32,2],[32,4,32,5],[32,7,32,8],[32,10,32,11],[47,1,47,2],[47,4,47,5],[47,7,47,8],[6,18,6,23],[12,1,13,2],[12,4,13,5],[12,7,13,8],[12,10,13,11]]}
["Western Colorado Perennial Grass and Biomass Budget Generator"]
[]
[null,"STEP 1           Choose Financial Settings.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,"Select financial settings from drop-down menu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-2]
[null,"Select:  Labor rate (per hour)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Select:  Operating interest (%/year)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,"Select:  Diesel fuel price (per gallon)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data lists for Drop Down Menus",null,null,null,null,null,null,null,null,0]
[null,"Select:  Irrigation cost (per acre)",null,null,null,null,null,null,null,null,null,null,null,null,"Macro key for run 1,2,3",null,null,null,"Labor Rate","Opp Interest rate","Fuel Price","Irrigation cost","Input use","Yield / Cutting",null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"STEP 2          Choose Crop Mix Scenario.  ",null,null,null,null,null,null,null,null,null,null,null,"Labor Rate (per hour)",{"$f":"C5","v":0},{"$f":"C5","v":0},{"$f":"C5","v":0},{"$f":"C5","v":0},null,null,null,null,null,null,null,7,null,0]
[null,"Select agronomic values from the drop-down menu of the desired crop mix.  Next, type in the commodity sales price.  Type in default fertilizer values or actual amount of fertilizer used.  Cost,revenue,  ",null,null,null,null,null,null,null,null,null,null,null,"Operating Interest Rate",{"$f":"C6","v":0},{"$f":"C6","v":0},{"$f":"C6","v":0},{"$f":"C6","v":0},7,0,2,10,"Low",null,null,0.02,null,0]
[null,"and break-even calculations appear, directly below. Values may be changed and saved as a \"Run\".  Change the values, save, and compare multiple Runs for each crop mix.",null,null,null,null,null,null,null,null,null,null,null,"Diesel Fuel Price (per gallon)",{"$f":"C7","v":0},{"$f":"C7","v":0},{"$f":"C7","v":0},{"$f":"C7","v":0},8,5.0000000000000001E-3,2.1,15,"High",0]
[null,"Native Mix Scenario:",null,null,"Introduced Mix Scenario:",null,null,"Tall Fescue Scenario:",null,null,"Switchgrass Scenario:",null,null,"Irrigation Cost (per acre)",{"$f":"C8","v":0},{"$f":"C8","v":0},{"$f":"C8","v":0},{"$f":"C8","v":0},9,0.01,2.2000000000000002,20,"Low",0.5,null,4,null,"Tall Fescue Scenario:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer Input:",{"$f":"C15","v":0},{"$f":"F15","v":0},{"$f":"I15","v":0},{"$f":"L15","v":0},10,1.4999999999999999E-2,2.2999999999999998,25,null,1,null,10,null,0]
[null,"Select:  Fertilizer intensity",null,null,"Select:  Fertilizer intensity",null,null,"Select:  Fertilizer intensity",null,null,"Select:  Fertilizer intensity",null,null,"Number of Cuttings:",{"$f":"C16","v":0},{"$f":"F16","v":0},{"$f":"I16","v":0},{"$f":"L16","v":0},11,0.02,2.4,30," ",1.5,null,"High",null,"Fertilizer Input:"]
[null,"Select:  Number of cuttings:",null,null,"Select:  Number of cuttings:",null,null,"Select:  Number of cuttings:",null,null,"Select:  Number of cuttings:",null,null,"Expected Yield (t/ac/cutting):",{"$f":"C17","v":0},{"$f":"F17","v":0},{"$f":"I17","v":0},{"$f":"L17","v":0},12,2.5000000000000001E-2,2.5,35,"One",2,null,"Three",null,"Number of Cuttings:"]
[null,"Select:  Expected yield (t/ac/cutting)",null,null,"Select:  Expected yield (t/ac/cutting)",null,null,"Select:  Expected yield (t/ac/cutting)",null,null,"Select:  Expected yield (t/ac/cutting)",null,null,"Sales Price ($/t)",0,0,0,0,13,0.03,2.6,40,"Two",2.5,null,2,null," "]
[null,"Enter:   Sales price ($/t)",null,null,"Enter:   Sales price ($/t)",null,null,"Enter:   Sales price ($/t)",null,null,"Enter:   Sales price ($/t)",null,null,"Fertilizer/Cutting in lbs./acre (default) ","","","","",14,3.5000000000000003E-2,2.7,45,"Three",3,null,2.5,null,"High Yield (t/ac/cutting):"]
[null,"             Default: fertilizer/cutting in lbs/ac",{"$f":"IF(C15=\"\",\"\",IF(C15=\"Low\", 30, 60))","v":""},null,"             Default: fertilizer/cutting in lbs/acre",{"$f":"IF(F15=\"\",\"\",IF(F15=\"Low\", 30, 60))","v":""},null,"             Default: fertilizer/cutting in lbs/acre",{"$f":"IF(I15=\"\",\"\",IF(I15=\"Low\", 30, 60))","v":""},null,"             Default: fertilizer/cutting in lbs/acre",{"$f":"IF(L15=\"\",\"\",IF(L15=\"Low\", 30, 60))","v":""},null,"Fertilizer/Cutting in lbs./acre (actual) ",0,0,0,0,15,0.04,2.8,50,null,3.5,null,150,null,"Sales Price ($/t)"]
[null,"Enter:   Actual fertilizer input",null,null,"Enter:   Actual fertilizer input",null,null,"Enter:   Actual fertilizer input",null,null,"Enter:   Actual fertilizer input",null,null,"Cost Per Acre:",{"$f":"C21","v":"NA"},{"$f":"F21","v":"NA"},{"$f":"I21","v":"NA"},{"$f":"L21","v":"NA"},16,4.4999999999999998E-2,2.9,55,null,4,null,60]
[null,"Result:  Cost per acre:",{"$f":"IF(C15=\"\",\"NA\", (IF(AND(C15=\"Low\",C16=\"Two\"),'Native Mix L Input-2 cut'!C71,IF(AND(C15=\"Low\",C16=\"One\"),'Native Mix L Input-1 cut'!C70,IF(AND(C15=\"High\",C16=\"Two\"),'Native Mix H Input-2 cut'!C71,IF(AND(C15=\"High\",C16=\"One\"),'Native Mix H Input-1 cut'!C71,IF(AND(C15=\"High\",C16=\"Three\"),'Native Mix H Input-3 cut'!C71,\"NA\")))))))","v":"NA"},null,"Result:  Cost per acre:",{"$f":"IF(F15=\"\",\"NA\",(IF(AND(F15=\"Low\",F16=\"Two\"),'Introduced Mix L Input-2 cut'!C71,IF(AND(F15=\"Low\",F16=\"One\"),'Introduced Mix L Input-1 cut'!C71,IF(AND(F15=\"High\",F16=\"Two\"),'Intoduced Mix H Input-2 cut'!C71,IF(AND(F15=\"High\",F16=\"One\"),'Introduced Mix H Input-1 cut'!C71,IF(AND(F15=\"High\",F16=\"Three\"),'Intoduced Mix H Input-3 cut'!C71,\"NA\")))))))","v":"NA"},null,"Result:  Cost per acre:",{"$f":"IF(I15=\"\",\"NA\",(IF(AND(I15=\"Low\",I16=\"Two\"),'Tall Fescue L Input-2 cut'!C71,IF(AND(I15=\"Low\",I16=\"One\"),'Tall Fescue L Input-1 cut'!C71,IF(AND(I15=\"High\",I16=\"Two\"),'Tall Fescue H Input-2 cut'!C71,IF(AND(I15=\"High\",I16=\"One\"),'Tall Fescue H Input-1 cut'!C71,IF(AND(I15=\"High\",I16=\"Three\"),'Tall Fescue H Input-3 cut'!C71,\"NA\")))))))","v":"NA"},null,"Result:  Cost per acre:",{"$f":"IF(C15=\"\",\"NA\", (IF(AND($L$15=\"Low\",$L$16=\"Two\"),'Switchgrass L Input-2 cut'!C71,IF(AND($L$15=\"Low\",$L$16=\"One\"),'Switchgrass L Input-1 cut'!C71,IF(AND($L$15=\"High\",$L$16=\"Two\"),'Switchgrass H Input-2 cut'!C78,IF(AND($L$15=\"High\",$L$16=\"One\"),'Switchgrass H Input-1 cut'!C77,IF(AND($L$15=\"High\",$L$16=\"Three\"),'Switchgrass H Input-3 cut'!C84,\"NA\")))))))","v":"NA"},null,"Net Revenue Per Acre:","NA","NA","NA","NA",17,0.05,3,60,null,4.5,null,60]
[null,"Result:  Net revenue per acre:",{"$f":"IF(C21=\"NA\", \"NA\", (IF(C16=\"one\",C18*C17-C21,(IF(C16=\"two\",C18*2*C17-C21,C18*3*C17-C21)))))","v":"NA"},null,"Result:  Net revenue per acre:",{"$f":"IF(F21=\"NA\", \"NA\", (IF(F16=\"one\",F18*F17-F21,(IF(F16=\"two\",F18*2*F17-F21,F18*3*F17-F21)))))","v":"NA"},null,"Result:  Net revenue per acre:",{"$f":"IF(I21=\"NA\", \"NA\", (IF(I16=\"one\",I18*I17-I21,(IF(I16=\"two\",I18*2*I17-I21,I18*3*I17-I21)))))","v":"NA"},null,"Result:  Net revenue per acre:",{"$f":"IF(L21=\"NA\", \"NA\", (IF(L16=\"one\",L18*L17-L21,(IF(L16=\"two\",L18*2*L17-L21,L18*3*L17-L21)))))","v":"NA"},null,"Break-even price ($/t)","NA","NA","NA","NA",18,5.5E-2,3.1,65,null,5,null,197.56809107388349]
[null,"Result:  Breakeven price ($/t)",{"$f":"IF(C21=\"NA\",\"NA\",(IF(C16=\"one\",C21/C17,IF(C16=\"two\",C21/(2*C17),C21/(3*C17)))))","v":"NA"},null,"Result:  Breakeven price ($/t)",{"$f":"IF(F21=\"NA\", \"NA\", (IF(F16=\"one\",F21/F17,IF(F16=\"two\",F21/(2*F17),F21/(3*F17)))))","v":"NA"},null,"Result:  Breakeven price ($/t)",{"$f":"IF(I21=\"NA\", \"NA\", (IF(I16=\"one\",I21/I17,IF(I16=\"two\",I21/(2*I17),I21/(3*I17)))))","v":"NA"},null,"Result:  Breakeven price ($/t)",{"$f":"IF(L21=\"NA\", \"NA\", (IF(L16=\"one\",L21/L17,IF(L16=\"two\",L21/(2*L17),L21/(3*L17)))))","v":"NA"},null,null,{"$f":"C24","v":0},{"$f":"F24","v":0},null,{"$f":"L24","v":0},19,0.06,3.2,70,null,5.5,null,702.43190892611653]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,20,6.5000000000000002E-2,3.3,75,null,6,null," "]
["STEP 3",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,21,7.0000000000000007E-2,3.4,80,null,6.5,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,7.4999999999999997E-2,3.5,85,null,7,null,2]
["Save Results.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,0.08,3.6,90,null,7.5]
["Compare up to ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,8.5000000000000006E-2,3.7,95,null,8]
["3 runs for each",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0.09,3.8,100]
["crop. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,9.5000000000000001E-2,3.9,105]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,0.1,4,110]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,0.105,4.0999999999999996,115]
[null,"Summary of Native Mix Scenario, Run 1:",null,null,"Summary of Introduced Mix Scenario, Run 1:",null,null,"Summary of Tall Fescue Scenario, Run 1:",null,null,"Summary of Switchgrass Scenario, Run 1:",null,null,null,null,null,null,null,29,0.11,4.2,120]
[null,"Labor Rate (per hour)",null,null,"Labor Rate (per hour)",null,null,"Labor Rate (per hour)",null,null,"Labor Rate (per hour)",null,null,null,null,null,null,null,30,0.115,4.3,125]
[null,"Operating Interest Rate",null,null,"Operating Interest Rate",null,null,"Operating Interest Rate",null,null,"Operating Interest Rate",null,null,null,null,null,null,null,31,0.12,4.4000000000000004,130]
[null,"Diesel Fuel Price (per gallon)",null,null,"Diesel Fuel Price (per gallon)",null,null,"Diesel Fuel Price (per gallon)",null,null,"Diesel Fuel Price (per gallon)",null,null,null,null,null,null,null,32,0.125,4.5,135]
[null,"Irrigation Cost (per acre)",null,null,"Irrigation Cost (per acre)",null,null,"Irrigation Cost (per acre)",null,null,"Irrigation Cost (per acre)",null,null,null,null,null,null,null,33,0.13,4.5999999999999996,140]
[null,"Fertilizer/Cutting (lbs/ac)",null,null,"Fertilizer/Cutting (lbs/ac)",null,null,"Fertilizer/Cutting (lbs/ac)",null,null,"Fertilizer/Cutting (lbs/ac)",null,null,null,null,null,null,null,null,0.13500000000000001,4.7,145]
[null,"Number of Cuttings:",null,null,"Number of Cuttings:",null,null,"Number of Cuttings:",null,null,"Number of Cuttings:",null,null,null,null,null,null,null,null,0.14000000000000001,4.8,150]
[null,"Expected Yield (t/ac/cutting):",null,null,"Expected Yield (t/ac/cutting):",null,null,"Expected Yield (t/ac/cutting):",null,null,"Expected Yield (t/ac/cutting):",null,null,null,null,null,null,null,null,0.14499999999999999,4.9000000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single"]
[null,"Sales Price ($/t)",null,null,"Sales Price ($/t)",null,null,"Sales Price ($/t)",null,null,"Sales Price ($/t)",null,null,null,null,null,null,null,null,0.15,5]
[null,"Fertilizer/Cutting  lbs/ac (default) ",null,null,"Fertilizer/Cutting  lbs/ac (default) ",null,null,"Fertilizer/Cutting  lbs/ac (default) ",null,null,"Fertilizer/Cutting  lbs/ac (default) ",null,null,null,null,null,null,null,null,null,5.0999999999999996]
[null,"Fertilizer/Cutting in lbs/ac (actual) ",null,null,"Fertilizer/Cutting in lbs/ac (actual) ",null,null,"Fertilizer/Cutting in lbs/ac (actual) ",null,null,"Fertilizer/Cutting in lbs/ac (actual) ",null,null,null,null,null,null,null,null,null,5.2]
[null,"Cost Per Acre:",null,null,"Cost Per Acre:",null,null,"Cost Per Acre:",null,null,"Cost Per Acre:"]
[null,"Net Revenue Per Acre:",null,null,"Net Revenue Per Acre:",null,null,"Net Revenue Per Acre:",null,null,"Net Revenue Per Acre:"]
[null,"Break-even price ($/t)",null,null,"Break-even price ($/t)",null,null,"Break-even price ($/t)",null,null,"Break-even price ($/t)"]
[]
[null,"Summary of Native Mix Scenario, Run 2:",null,null,"Summary of Introduced Mix Scenario, Run 2:",null,null,"Summary of Tall Fescue Scenario, Run 2:",null,null,"Summary of Switchgrass Scenario, Run 2:",10]
[null,"Labor Rate (per hour)",null,null,"Labor Rate (per hour)",null,null,"Labor Rate (per hour)",null,null,"Labor Rate (per hour)"]
[null,"Operating Interest Rate",null,null,"Operating Interest Rate",null,null,"Operating Interest Rate",null,null,"Operating Interest Rate"]
[null,"Diesel Fuel Price (per gallon)",null,null,"Diesel Fuel Price (per gallon)",null,null,"Diesel Fuel Price (per gallon)",null,null,"Diesel Fuel Price (per gallon)"]
[null,"Irrigation Cost (per acre)",null,null,"Irrigation Cost (per acre)",null,null,"Irrigation Cost (per acre)",null,null,"Irrigation Cost (per acre)"]
[null,"Fertilizer/cutting (lbs/ac)",null,null,"Fertilizer/cutting (lbs/ac)",null,null,"Fertilizer/cutting (lbs/ac)",null,null,"Fertilizer/cutting (lbs/ac)"]
[null,"Number of Cuttings:",null,null,"Number of Cuttings:",null,null,"Number of Cuttings:",null,null,"Number of Cuttings:"]
[null,"Expected Yield (t/ac/cutting):",null,null,"Expected Yield (t/ac/cutting):",null,null,"Expected Yield (t/ac/cutting):",null,null,"Expectd Yield (t/ac/cutting):"]
[null,"Sales Price ($/t)",null,null,"Sales Price ($/t)",null,null,"Sales Price ($/t)",null,null,"Sales Price ($/t)"]
[null,"Fertilizer/Cutting  lbs/ac (default) ",null,null,"Fertilizer/Cutting  lbs/ac (default) ",null,null,"Fertilizer/Cutting  lbs/ac (default) ",null,null,"Fertilizer/Cutting  lbs/ac (default) "]
[null,"Fertilizer/Cutting in lbs/ac (actual) ",null,null,"Fertilizer/Cutting in lbs/ac (actual) ",null,null,"Fertilizer/Cutting in lbs/ac (actual) ",null,null,"Fertilizer/Cutting in lbs/ac (actual) "]
[null,"Cost Per Acre:",null,null,"Cost Per Acre:",null,null,"Cost Per Acre:",null,null,"Cost Per Acre:"]
[null,"Net Revenue Per Acre:",null,null,"Net Revenue Per Acre:",null,null,"Net Revenue Per Acre:",null,null,"Net Revenue Per Acre:"]
[null,"Break-even price ($/t)",null,null,"Break-even price ($/t)",null,null,"Break-even price ($/t)",null,null,"Break-even price ($/t)"]
[]
[null,"Results From Native Mix Scenario, Run 3:",null,null,"Summary of Introduced Mix Scenario, Run 3:",null,null,"Summary of Tall Fescue Scenario, Run 3",null,null,"Summary of Switchgrass Scenario, Run 3:"]
[null,"Labor Rate (per hour)",null,null,"Labor Rate (per hour)",null,9,"Labor Rate (per hour)",null,null,"Labor Rate (per hour)"]
[null,"Operating Interest Rate",null,null,"Operating Interest Rate",null,0.02,"Operating Interest Rate",null,null,"Operating Interest Rate"]
[null,"Diesel Fuel Price (per gallon)",null,null,"Diesel Fuel Price (per gallon)",null,2.2000000000000002,"Diesel Fuel Price (per gallon)",null,null,"Diesel Fuel Price (per gallon)"]
[null,"Irrigation Cost (per acre)",null,null,"Irrigation Cost (per acre)",null,30,"Irrigation Cost (per acre)",null,null,"Irrigation Cost (per acre)"]
[null,"Fertilizer/cutting (lbs/ac)",null,null,"Fertilizer/cutting (lbs/ac)",null,"Low","Fertilizer/cutting (lbs/ac)",null,null,"Fertilizer/cutting (lbs/ac)"]
[null,"Number of Cuttings:",null,null,"Number of Cuttings:",null,"Two","Number of Cuttings:",null,null,"Number of Cuttings:"]
[null,"Expected Yield (t/ac/cutting)",null,null,"Expected Yield (t/ac/cutting)",null,1.5,"Expected Yield (t/ac/cutting)",null,null,"Expected Yield (t/ac/cutting):"]
[null,"Sales Price ($/t)",null,null,"Sales Price ($/t)",null,200,"Sales Price ($/t)",null,null,"Sales Price ($/t)"]
[null,"Fertilizer/Cutting  lbs/ac (default) ",null,null,"Fertilizer/Cutting  lbs/ac (default) ",null,30,"Fertilizer/Cutting  lbs/ac (default) ",null,null,"Fertilizer/Cutting  lbs/ac (default) "]
[null,"Fertilizer/Cutting in lbs/ac (actual) ",null,null,"Fertilizer/Cutting in lbs/ac (actual) ",null,30,"Fertilizer/Cutting in lbs/ac (actual) ",null,null,"Fertilizer/Cutting in lbs/ac (actual) "]
[null,"Cost Per Acre:",null,null,"Cost Per Acre:",null,131.4877027632462,"Cost Per Acre:",null,null,"Cost Per Acre:"]
[null,"Net Revenue Per Acre:",null,null,"Net Revenue Per Acre:",null,468.5122972367538,"Net Revenue Per Acre:",null,null,"Net Revenue Per Acre:"]
[null,"Break-even price ($/t)",null,null,"Break-even price ($/t)",null,43.829234254415404,"Break-even price ($/t)",null,null,"Break-even price ($/t)"]

{"sheet":"Instructions","index":24,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Directions for Using the Western Colorado Perennial Grass and Biomass Budget Generator"]
[]
[null,"This budget calculator provides farmers with a tool for estimating the operating costs, revenues, and profitability of growing perennial grasses in western Colorado.  Farmers can compare different agricultural scenarios  by selecting customized financial and agronomic values.  The farmer's customized settings are combined with agricultural operating and financial formulas housed within the spreadsheet.  This information is used to calculate a one-year budget for growing biomass and perennial grass, with the first year of establishment costs amortized into the budget."]
[null,"A step-by-step guide is provided below, followed by a description of basic assumptions."]
[]
[null,"Budget estimates can be generated in three steps:"]
[]
[null,"Step 1:  Select Financial Settings.  Click on the shaded cells, then click on the ⏏ symbol to review a range of values.  Click to select the appropriate value, and a checkmark will appear next to the selection.   This value will be transferred into the cell.                                                                                                                         Labor rates can be applied to all labor (including an owner-operator, if desired).   The interest rate reflects the interest rate (per year) paid on all operating costs.    Irrigation costs consist of all operating costs incurred per year (labor, fuel, water charges, etc).  "]
[]
[null,"Step 2:  Select Crop Mix Scenario and Enter Operational Parameters.  Enter the amount for each of the shaded cells in the second section, including: Fertilizer intensity, number of cuttings, expected yield, expected price of yield, and actual fertilizer used.  Each step is explained in greater detail below.  Cost per acre, net revenue and breakeven price are all reported at the end of this section."]
[]
[null,"Fertilizer Intensity.  Click on the ⏏ symbol to select “High” or “Low” fertilizer inputs in order to generate a default value.  A checkmark will appear next to the selection.  “High” fertilizer reflects a default value of 60 lbs./cutting/acre of Nitrogen fertilizer.  “Low” fertilizer reflects a default value of 30 lbs./cutting/acre of Nitrogen fertilizer per application.  Please note that \"fertilizer intensity\" will be used to generate default values that can be entered as the actual amount of fertilizer used in each cutting."]
[]
[null,"Note:  In order to generate three cuttings, “high” amounts of fertilizer input are necessary.  “Low” amounts of fertilizer are not an option for three cuttings, and “NA” will appear in the results when this selection is made.  "]
[]
[null,"Number of cuttings:  Click on the ⏏ symbol to select from One, Two, or Three cuttings.  "]
[]
[null,"“Expected yield”:  Click on the ⏏ symbol to select the anticipated yield, expressed in tons/acre/cutting.  Preliminary yield results for growing perennial grasses in Western Colorado have been reported at the Western Agricultural Experiment Station in Fruita (Pearson et al., 2012.)  For more specific information about input and yield data, please click on the Pearson et al. 2012 button."]
[]
[null,"Sales price:  Enter the expected sales price in $/ton, to calculate the break-even prices and expected profitability.  Like many experimental crops, it may take some effort to find perennial grass price data.  The County Extension Office, industry, or regional bio-refineries are good resources for this information."]
[]
[null,"Default or actual fertilizer/cutting in lbs./acre:  Enter either the default values or the actual amount of fertilizer used in each cutting.  Default fertilizer values are calculated when “high” or “low” fertilizer settings are selected.  Fertilizer values are based upon control trials at the Western Colorado Ag Experiment Station in Fruita (Pearson et al., 2012), but farmers can enter their own fertilizer values."]
[]
[null,"Step 3: Save and Compare Different Scenarios.  Save your current run by clicking on “SaveRun1”.  Next, modify the information in steps 1 and 2 as desired, and save as Run 2.  Compare how changes in financial or agronomic inputs affect cost and break-even prices.  Save up to three different runs, by clicking “Save Run”.  Please note that Macros need to be enabled in order to save the runs."]
[]
[null,"Asssumptions"]
[null,"About the Budget Generator:  Perennial grass production is still considered an experimental venture. However, recent research shows that it is agronomically feasible to establish and grow several grass varieties in western Colorado (Pearson et al., 2012).  A logical follow-up question is whether it is economically feasible to do so.  For more detailed information about yield, output, and inputs used in this calculator, please click on the link.  "]
[]
[null,"Calculating the economic feasibility of farm-scale perennial grass production is a step towards resolving the “chicken and egg” biofuel production dilemma.  While bio-refineries need an assurance that feedstock will be available for production, farmers won’t engage in long-term perennial grass production, unless they have a handle on estimated costs.   Therefore, users are asked to view the budget generator in proper context.  It is a tool built upon preliminary agronomic and economic data for western Colorado that may be useful for farmers to calculate farm-level costs for perennial grass production.  It our hope that this tool will jump start conversations and projects that will eventually lead to a more sophisticated understanding of the agronomic and economic potential for perennial grass production in western Colorado.  "]
[]
[null,"In summary, this tool actually generates partial budgets, because more calculations are being made internally than can be viewed on the screen.  There are some production costs (e.g. pesticide application) that are being computed internally and that are not expected to change by the different type of grass.  Therefore, in the interest of making this tool as straight-forward as possible, these costs are not presented on the screen.  Since growing perennial grass for biomass is considered an experimental venture, please provide feedback to the Western Colorado Research Center, Agricultural Experiment Station-Fruita about how to improve upon this tool:  970-434-3264.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Mention of a trademark or proprietary product does not constitute endorsement by the Colorado Agricultural Experiment Station."]
[]
[null,"Disclaimer:  Colorado State University is an equal opportunity/affirmative action institution and complies with all Federal and Colorado State laws, regulations, and executive orders regarding affirmative action requirements  in all programs. The Office of Equal Opportunity is located in 101 Student Services. In order to assist Colorado State University in meeting its affirmative action responsibilities, ethnic minorities, women, and other protected class members are encouraged to apply and to so identify themselves."]
[null,"pwgrass"]